Database Comparer VCL version 8.0

Database Comparer VCL compares and synchronizes databases structures (metadata) and table data of many popular databases.

A list of supported databases is constantly updated and extended: InterBase, FireBird, MySQL, MSSQL, Oracle, Sybase, PostgreSQL, DB2, PervasiveSQL, MSAccess, Paradox, DBASE, and other databases that can be accessed via the OLEDB provider. Didn't find your database in this list? Probably, we will add it soon. Join us and stay tuned.

Most popular connection libraries, such as FireDAC, ADO, and IBX are supported directly. Some third-party libraries, such as UniDAC, IBDDAC, IBObjects, ZEOS, AnyDAC, etc are supported as well.

You can even use outdated connection methods, such as BDE or FIB to connect to your databases.

The Database Comparer VCL product includes more than 40 components for the database-related development. All these components are constantly being refined and improved.

What's new in Version 8.0

Implemented features

TDBComparer is the key component, which performs most of the work: comparing two databases and producing the final update SQL script. This SQL script contains all necessary SQL statements to make the target database structure identical to the source database structure.

To extract the database structure the TxxxDBExtract component is used. Here, xxx varies, depending on your database type, e.g. TIBDBExtract in case of Interbase/ Firebird.

The other component, TxxxScriptExtract, is used to extract structure from an SQL DDL script (for xxx see the explanation above).

The extracted database structure is saved in to the TDBStructure component.

You can execute the update SQL script using an SQL management tool for your database or using the TxxxSQLExec component.

A set of TDBCConnectionXXX components are used to connect to your database, depending on your database type and the selected DB connection library.

The TTableDataComparer component synchronizes table data and gives you the full control over the Insert, Update, and Delete operations. This component can produce an update script, which includes the INSERT/UPDATE/DELETE SQL statements, and also can immediately update the target table during the synchronization process.

Visit our site Clever Components to learn more about our products.

Join us on Facebook, Twitter, Telegram, Newsletter

Watch our YouTube channel.

Tutorials, demos, and example are available on GitHub

Fixed bugs

Known problems and restrictions

Demo / Trial version

Free Demo version of Database Comparer VCL is available for evaluation purposes only.
Demo version displays trial warning messages if components are used in GUI applications, all other features are completely available.

For more details please visit our Customer Portal

Copyright © 1999 - 2021 www.clevercomponents.com